[dbo].[BAEGetSuperProductAttributes]
create procedure [dbo].[BAEGetSuperProductAttributes] @SuperProductID int as
SELECT b.OrderSuperProductAttributeID, b.Title, b.Code, a.SortOrder
FROM OrderSuperProductAttributeLookup AS a
INNER JOIN OrderSuperProductAttribute AS b ON a.OrderSuperProductAttributeID = b.OrderSuperProductAttributeID
WHERE a.OrderProductID = @SuperProductID
ORDER BY a.SortOrder ASC
GO
